<ViewGenerator>
		<strStateColorMappingFile>/opt/jilroy/checkit//conf/viewgenerators/StateColorDefaultMapping.map</strStateColorMappingFile>
		<strPreExecuteCommand>null</strPreExecuteCommand>
		<strReExecFrequency>null</strReExecFrequency>
	<SymbolGenerator>
		<strUUID>1</strUUID>
		<strParentUUID>1</strParentUUID>
		<strViewUUID>1</strViewUUID>
		<strName>Backbone</strName>
		<strType>View</strType>
		<strSymbolType>null</strSymbolType>
		<strSymbolSubType>null</strSymbolSubType>
		<strDescription>null</strDescription>
		<strLabel>Backbone view</strLabel>
		<strState>null</strState>
		<strIconName>View</strIconName>
		<strBackgroundImage>null</strBackgroundImage>
		<strLayout>Circle</strLayout>
		<strUserData>null</strUserData>
		<strColorSource>null</strColorSource>
		<strWeight>null</strWeight>
		<strXPos>null</strXPos>
		<strYPos>null</strYPos>
		<strStateColorMappingFile>/opt/jilroy/checkit//conf/viewgenerators/StateColorDefaultMapping.map</strStateColorMappingFile>
		<strPreExecuteCommand>null</strPreExecuteCommand>
		<strReExecFrequency>null</strReExecFrequency>
	</SymbolGenerator>
	<SymbolGenerator>
		<strUUID>e22b2bb4-a9c6-4bd9-9b04-b1e4c41efc38</strUUID>
		<strParentUUID>1</strParentUUID>
		<strViewUUID>1</strViewUUID>
		<strName>BackboneRouters</strName>
		<strType>SQL</strType>
		<strSymbolType>null</strSymbolType>
		<strSymbolSubType>null</strSymbolSubType>
		<strDescription>null</strDescription>
		<strLabel>null</strLabel>
		<strState>null</strState>
		<strIconName>/opt/jilroy/checkit//resource/mapicons/for_map/router.gif</strIconName>
		<strBackgroundImage>null</strBackgroundImage>
		<strLayout>Grid</strLayout>
		<strUserData>nObjectId = @nObjectId@</strUserData>
		<strColorSource>null</strColorSource>
		<strWeight>null</strWeight>
		<strXPos>null</strXPos>
		<strYPos>null</strYPos>
		<strDriverName>null</strDriverName>
		<strManager>null</strManager>
		<strUser>null</strUser>
		<strPassword>null</strPassword>
		<strCommand>SELECT 
strName,nObjectId 
FROM tblObject
WHERE 
nIsRouter = 1 and strtype = 'Node'</strCommand>
		<strSQLQueryFieldName>null</strSQLQueryFieldName>
	</SymbolGenerator>
	<SymbolGenerator>
		<strUUID>2021c5eb-e48f-4bdb-9d51-5e13d18f1c74</strUUID>
		<strParentUUID>1</strParentUUID>
		<strViewUUID>1</strViewUUID>
		<strName>Subnets</strName>
		<strType>SQL</strType>
		<strSymbolType>null</strSymbolType>
		<strSymbolSubType>null</strSymbolSubType>
		<strDescription>null</strDescription>
		<strLabel>null</strLabel>
		<strState>null</strState>
		<strIconName>/opt/jilroy/checkit//resource/mapicons/for_map/networking.gif</strIconName>
		<strBackgroundImage>null</strBackgroundImage>
		<strLayout>Grid</strLayout>
		<strUserData>null</strUserData>
		<strColorSource>null</strColorSource>
		<strWeight>null</strWeight>
		<strXPos>null</strXPos>
		<strYPos>null</strYPos>
		<strDriverName>null</strDriverName>
		<strManager>null</strManager>
		<strUser>null</strUser>
		<strPassword>null</strPassword>
		<strCommand>SELECT
DISTINCT strSubnetAddr
FROM tblObject
WHERE
strType = 'Address' AND strIPADDR != '127.0.0.1' 
AND strSubnetAddr IS NOT NULL
AND  strSubnetAddr != 'null'</strCommand>
		<strSQLQueryFieldName>null</strSQLQueryFieldName>
	</SymbolGenerator>
	<SymbolGenerator>
		<strUUID>2f3d90ce-ad8c-4107-8932-86bacec3d571</strUUID>
		<strParentUUID>1</strParentUUID>
		<strViewUUID>1</strViewUUID>
		<strName>NewLinkGenerator</strName>
		<strType>LinkSQL</strType>
		<strSymbolType>null</strSymbolType>
		<strSymbolSubType>null</strSymbolSubType>
		<strDescription>null</strDescription>
		<strLabel>null</strLabel>
		<strState>null</strState>
		<strIconName>null</strIconName>
		<strBackgroundImage>null</strBackgroundImage>
		<strLayout>Grid</strLayout>
		<strUserData>null</strUserData>
		<strColorSource>None</strColorSource>
		<strWeight>null</strWeight>
		<strXPos>null</strXPos>
		<strYPos>null</strYPos>
		<fIsDirectional>0</fIsDirectional>
		<strColorSource>None</strColorSource>
		<strSQLCommand>select
RouterSymbol.strUUID,
SubnetSymbol.strUUID,
RouterAddress.nObjectId,
RouterInterface.strName || '==' || SubnetSymbol.strName
FROM
tblMapSymbols RouterSymbol INNER JOIN tblObject RouterNode ON RouterSymbol.strName = RouterNode.strName 
INNER JOIN tblMapSymbols SubnetSymbol ON SubnetSymbol.strViewGeneratorUUID = RouterSymbol.strViewGeneratorUUID 
INNER JOIN tblObject RouterInterface ON RouterNode.nObjectId = RouterInterface.nParentObjectId 
INNER JOIN tblObject RouterAddress ON RouterNode.nObjectId = RouterAddress.nParentObjectId AND RouterAddress.nIfIndex = RouterInterface.nIfIndex 
AND SubnetSymbol.strName = RouterAddress.strSubnetAddr 
WHERE
RouterAddress.strType = 'Address' AND
RouterNode.strType = 'Node' AND
RouterInterface.strType = 'Interface' AND
RouterNode.nIsRouter = 1</strSQLCommand>
	</SymbolGenerator>
	<SymbolGenerator>
		<strUUID>6edd4868-be23-4e06-ba0a-650dd7cca402</strUUID>
		<strParentUUID>e22b2bb4-a9c6-4bd9-9b04-b1e4c41efc38</strParentUUID>
		<strViewUUID>1</strViewUUID>
		<strName>Interfaces</strName>
		<strType>SQL</strType>
		<strSymbolType>null</strSymbolType>
		<strSymbolSubType>null</strSymbolSubType>
		<strDescription>null</strDescription>
		<strLabel>null</strLabel>
		<strState>null</strState>
		<strIconName>/opt/jilroy/checkit//resource/mapicons/for_map/computer-card.gif</strIconName>
		<strBackgroundImage>null</strBackgroundImage>
		<strLayout>Grid</strLayout>
		<strUserData>nObjectId = @nObjectId@</strUserData>
		<strColorSource>@nObjectId@</strColorSource>
		<strWeight>null</strWeight>
		<strXPos>null</strXPos>
		<strYPos>null</strYPos>
		<strDriverName>null</strDriverName>
		<strManager>null</strManager>
		<strUser>null</strUser>
		<strPassword>null</strPassword>
		<strCommand>SELECT 
strName,nObjectId
FROM  tblObject 
WHERE 
nParentObjectId = @nObjectId@ AND 
strtype = 'Interface' AND
nIfIndex != -1 AND
strDescription != 'Java API discovered name'</strCommand>
		<strSQLQueryFieldName>null</strSQLQueryFieldName>
	</SymbolGenerator>
	<SymbolGenerator>
		<strUUID>1cb2a9d4-c78d-42cf-a575-514d19c42336</strUUID>
		<strParentUUID>e22b2bb4-a9c6-4bd9-9b04-b1e4c41efc38</strParentUUID>
		<strViewUUID>1</strViewUUID>
		<strName>Addresses</strName>
		<strType>SQL</strType>
		<strSymbolType>null</strSymbolType>
		<strSymbolSubType>null</strSymbolSubType>
		<strDescription>null</strDescription>
		<strLabel>null</strLabel>
		<strState>null</strState>
		<strIconName>/opt/jilroy/checkit//resource/mapicons/for_map/computer-card.gif</strIconName>
		<strBackgroundImage>null</strBackgroundImage>
		<strLayout>Grid</strLayout>
		<strUserData>nObjectId = @nObjectId@</strUserData>
		<strColorSource>@nObjectId@</strColorSource>
		<strWeight>null</strWeight>
		<strXPos>null</strXPos>
		<strYPos>null</strYPos>
		<strDriverName>null</strDriverName>
		<strManager>null</strManager>
		<strUser>null</strUser>
		<strPassword>null</strPassword>
		<strCommand>SELECT 
distinct Addresses.strName,Addresses.nObjectId nObjectid
FROM  tblObject Addresses, tblObject Interfaces 
WHERE 
Addresses.nParentObjectId = @nObjectId@ AND 
Interfaces.nParentObjectId = @nObjectId@ AND 
Addresses.strtype = 'Address' AND
Interfaces.strtype = 'Interface' AND
(    Addresses.nIfIndex = -1 OR 
     Interfaces.strDescription = 'Java API discovered name'
)</strCommand>
		<strSQLQueryFieldName>null</strSQLQueryFieldName>
	</SymbolGenerator>
	<SymbolGenerator>
		<strUUID>5ea27336-fe8e-4614-ac7f-cc4b37fcbdbf</strUUID>
		<strParentUUID>2021c5eb-e48f-4bdb-9d51-5e13d18f1c74</strParentUUID>
		<strViewUUID>1</strViewUUID>
		<strName>subnetNodes</strName>
		<strType>SQL</strType>
		<strSymbolType>null</strSymbolType>
		<strSymbolSubType>null</strSymbolSubType>
		<strDescription>null</strDescription>
		<strLabel>null</strLabel>
		<strState>null</strState>
		<strIconName>/opt/jilroy/checkit//resource/mapicons/for_map/desktop.gif</strIconName>
		<strBackgroundImage>null</strBackgroundImage>
		<strLayout>Grid</strLayout>
		<strUserData>nObjectId = @nObjectId@</strUserData>
		<strColorSource>null</strColorSource>
		<strWeight>null</strWeight>
		<strXPos>null</strXPos>
		<strYPos>null</strYPos>
		<strDriverName>null</strDriverName>
		<strManager>null</strManager>
		<strUser>null</strUser>
		<strPassword>null</strPassword>
		<strCommand>SELECT 
distinct Node.strName, Node.nObjectId nObjectId
FROM tblObject Address 
INNER JOIN tblObject Node 
          ON Address.nParentObjectId = Node.nObjectId
WHERE 
Node.strType = 'Node' AND
Address.strSubnetAddr = '@strSubnetAddr@'</strCommand>
		<strSQLQueryFieldName>null</strSQLQueryFieldName>
	</SymbolGenerator>
	<SymbolGenerator>
		<strUUID>f43a3d94-9e93-4885-ab13-509c74c657b7</strUUID>
		<strParentUUID>5ea27336-fe8e-4614-ac7f-cc4b37fcbdbf</strParentUUID>
		<strViewUUID>1</strViewUUID>
		<strName>Interfaces</strName>
		<strType>SQL</strType>
		<strSymbolType>null</strSymbolType>
		<strSymbolSubType>null</strSymbolSubType>
		<strDescription>null</strDescription>
		<strLabel>null</strLabel>
		<strState>null</strState>
		<strIconName>/opt/jilroy/checkit//resource/mapicons/for_map/computer-card.gif</strIconName>
		<strBackgroundImage>null</strBackgroundImage>
		<strLayout>Grid</strLayout>
		<strUserData>nObjectId = @nObjectId@</strUserData>
		<strColorSource>@nObjectId@</strColorSource>
		<strWeight>null</strWeight>
		<strXPos>null</strXPos>
		<strYPos>null</strYPos>
		<strDriverName>null</strDriverName>
		<strManager>null</strManager>
		<strUser>null</strUser>
		<strPassword>null</strPassword>
		<strCommand>SELECT 
strName,
nObjectId  
FROM  tblObject 
WHERE 
nParentObjectId = @nObjectId@ AND 
strtype = 'Interface' AND
nIfIndex != -1  AND
strDescription != 'Java API discovered name'</strCommand>
		<strSQLQueryFieldName>null</strSQLQueryFieldName>
	</SymbolGenerator>
	<SymbolGenerator>
		<strUUID>cacd5f80-33d6-4ba5-ba86-1b10b5c89e5f</strUUID>
		<strParentUUID>5ea27336-fe8e-4614-ac7f-cc4b37fcbdbf</strParentUUID>
		<strViewUUID>1</strViewUUID>
		<strName>Addresses</strName>
		<strType>SQL</strType>
		<strSymbolType>null</strSymbolType>
		<strSymbolSubType>null</strSymbolSubType>
		<strDescription>null</strDescription>
		<strLabel>null</strLabel>
		<strState>null</strState>
		<strIconName>/opt/jilroy/checkit//resource/mapicons/for_map/computer-card.gif</strIconName>
		<strBackgroundImage>null</strBackgroundImage>
		<strLayout>Grid</strLayout>
		<strUserData>nObjectId = @nObjectId@</strUserData>
		<strColorSource>@nObjectId@</strColorSource>
		<strWeight>null</strWeight>
		<strXPos>null</strXPos>
		<strYPos>null</strYPos>
		<strDriverName>null</strDriverName>
		<strManager>null</strManager>
		<strUser>null</strUser>
		<strPassword>null</strPassword>
		<strCommand>SELECT 
distinct Addresses.strName,Addresses.nObjectId nObjectid
FROM  tblObject Addresses, tblObject Interfaces 
WHERE 
Addresses.nParentObjectId = @nObjectId@ AND 
Interfaces.nParentObjectId = @nObjectId@ AND 
Addresses.strtype = 'Address' AND
Interfaces.strtype = 'Interface' AND
(    Addresses.nIfIndex = -1 OR 
     Interfaces.strDescription = 'Java API discovered name'
)</strCommand>
		<strSQLQueryFieldName>null</strSQLQueryFieldName>
	</SymbolGenerator>
</ViewGenerator>
